/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
use DBCursoDotNetDEV
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.TBProfissional
	(
	IDProfissional int NOT NULL IDENTITY (1, 1),
	Nome varchar(50) NOT NULL,
	Nascimento date NOT NULL,
	Email varchar(30) NOT NULL,
	CPF char(11) NOT NULL,
	Sexo char(1) NOT NULL,
	Estado char(2) NOT NULL,
	Cidade varchar(30) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.TBProfissional ADD CONSTRAINT
	PK_TBProfissional PRIMARY KEY CLUSTERED 
	(
	IDProfissional
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.TBProfissional SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
